﻿CREATE TABLE [dbo].[Cliente] (
    [Id]                INT          IDENTITY (1, 1) NOT NULL,
    [Nombre]            VARCHAR (50) NOT NULL,
    [Cedula]            VARCHAR (25) NULL,
    [Telefono]          VARCHAR (20) NULL,
    [ContactoNombre]    VARCHAR (50) NULL,
    [ContactoTelefono]  VARCHAR (20) NULL,
    [ContactoExtension] VARCHAR (10) NULL,
    [ContactoCorreo]    VARCHAR (50) NULL,
    [EmpresaId]         INT          NOT NULL,
    [Activo] BIT NOT NULL DEFAULT 0, 
    CONSTRAINT [PK_Cliente] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_Cliente_Empresa] FOREIGN KEY ([EmpresaId]) REFERENCES [dbo].[Empresa] ([Id])
);

